<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib  prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib  prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%>
<%@ taglib  prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<%@ taglib prefix="redis" uri="http://www.shopjsp.com/redisTag/functions" %>
<%@ taglib prefix="shiro" uri="http://shiro.apache.org/tags" %>
<c:set var="basePath" value="${redis:getSysConfig('base_path_back')}"/>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <title>会员统计信息</title>

	  <jsp:include page="../../util/import.jsp"/>
	  <script type="text/javascript">
          $(function(){

              var $tt= $("#tt").bootstrapTable({
                  url: '${basePath}/back/customerStatistics/listCustomerStatistics.sjson',         	/**请求后台的URL（*）**/
                  method: 'post',                      	/**请求方式（*）**/
                  contentType: "application/x-www-form-urlencoded",
                  dataType: 'json',
                  toolbar: '#toolbar',               	/**工具按钮用哪个容器**/
                  striped: true,                      	/**是否显示行间隔色**/
                  cache: false,                       	/**是否使用缓存，默认为true，所以一般情况下需要设置一下这个属性（*）**/
                  pagination: true,                   	/**是否显示分页（*）**/
                  sortable: false,                    	/**是否启用排序**/
                  sortOrder: 'asc',                   	/**排序方式**/
                  queryParamsType: '',
                  sidePagination: 'server',           	/**分页方式：client客户端分页，server服务端分页（*）**/
                  pageNumber: 1,
                  pageSize:10,							/**初始化加载第一页，默认第一页**/
                  pageList: [5,10, 25, 50],        	    /**可供选择的每页的行数（*）**/
                  search: false,                       	/**是否显示表格搜索，此搜索是客户端搜索，不会进服务端，所以，个人感觉意义不大**/
                  strictSearch: true,
                  showColumns: true,                  	/**是否显示所有的列**/
                  showRefresh: true,                  	/**是否显示刷新按钮**/
                  minimumCountColumns: 2,             	/**最少允许的列数**/
                  clickToSelect: true,                	/**是否启用点击选中行**/
                  uniqueId: 'customerId',               /**每一行的唯一标识，一般为主键列**/
                  singleSelect  : true,                 /**单选checkbox**/
                  showToggle:false,                    	/**是否显示详细视图和列表视图的切换按钮**/
                  cardView: false,                    	/**是否显示详细视图**/
                  detailView: false,                  	/**是否显示父子表**/
                  columns: [
                      {checkbox: true},
                      {field: 'Number', title: '编号',align: 'center',valign: 'middle',width:'50px',
                          formatter: function (value, row, index) {
                              var page = $tt.bootstrapTable("getPage");
                              return page.pageSize * (page.pageNumber - 1) + index + 1;
                          }
                      },
                      {field:"loginName",title:"会员名称",align: 'center', valign: 'middle'},
                      {field:"salesCount",title:"已付款订单数量（单）",align: 'center', valign: 'middle',
                          formatter:function(value,rowData,rowIndex){ //function里面的三个参数代表当前字段值，当前行数据对象，行号（行号从0开始）
                              if(value==null){
                                  return "0";
                              }else{
                                  return value;
                              }
                          }
                      },
                      {field:"salesPrice",title:"已付款订单金额（元）",align: 'center', valign: 'middle',
                          formatter:function(value,rowData,rowIndex){ //function里面的三个参数代表当前字段值，当前行数据对象，行号（行号从0开始）
                              if(value==null){
                                  return "0";
                              }else{
                                  return value;
                              }
                          }
                      },
                      {field:"refundCount",title:"已退货订单数量（单）",align: 'center', valign: 'middle',
                          formatter:function(value,rowData,rowIndex){ //function里面的三个参数代表当前字段值，当前行数据对象，行号（行号从0开始）
                              if(value==null){
                                  return "0";
                              }else{
                                  return value;
                              }
                          }
                      },
                      {field:"refundPrice",title:"已退货订单金额（元）",align: 'center', valign: 'middle',
                          formatter:function(value,rowData,rowIndex){ //function里面的三个参数代表当前字段值，当前行数据对象，行号（行号从0开始）
                              if(value==null){
                                  return "0";
                              }else{
                                  return value;
                              }
                          }
                      }
                  ],
                  queryParams: function (params) {
                      /**特别说明，返回的参数的值为空，则当前参数不会发送到服务器端,这种指定请求参数的方式和datatables控价类似**/
                      params.loginName = $("#q_loginName").val();
                      params.createTimeStart = $("#q_createTime_start").val();
                      params.createTimeEnd = $("#q_createTime_end").val();
                      params.currentPage = params.pageNumber;
                      return params;
                  }
              });

          });

          /**导出excel**/
          <shiro:hasPermission name="back_gotoCustomerStatistics_export">
			  function exportCustomerStatisticsExcel() {
				  window.location.href="${basePath}/back/customerStatistics/exportCustomerStatisticsExcel.inhtm?loginName="+$("#q_loginName").val()+"&createTimeStart="+$("#q_createTime_start").val()+"&createTimeEnd="+$("#q_createTime_end").val();
			  }
		  </shiro:hasPermission>

	  </script>
</head>

  <div class="panel-body" id="customer-main-panel">
	  <!-- 查询条件 -->
	  <div class="panel panel-default">
		  <div class="panel-heading">会员统计查询</div>
		  <div class="panel-body">
			  <form id="qform" class="form-horizontal">
				  <div class="form-group" style="margin-top:15px">
					  <div class="col-sm-3" >
						  <div class="input-group input-group-sm">
							  <span class="input-group-addon">会员名称</span>
							  <input type="text" class="form-control" id="q_loginName" name="typeName" placeholder="请输入会员名称"/>
						  </div>
					  </div>
					  <div class="col-sm-3" style="width: 340px;">
						  <div class="input-group input-group-sm ">
							  <span class="input-group-addon">交易开始时间</span>
							  <div class="input-group date form_datetime" data-link-field="dtp_input1">
								  <input id="q_createTime_start" name="q_createTime_start" style="height: 30px; border: 1px solid #c6c6c6;border-right:none;padding-left:10px; " size="17.5" type="text" value=""  placeholder="请选择交易开始时间" readonly>
								  <span class="input-group-addon"><span class="glyphicon glyphicon-remove"></span></span>
								  <span class="input-group-addon"><span class="glyphicon glyphicon-th"></span></span>
							  </div>
							  <script type="text/javascript">
                                  $('.form_datetime').datetimepicker({format: "yyyy-MM-dd",language:'zh-CN',weekStart:1, todayBtn:1,autoclose: 1,todayHighlight: 1,startView: 2, minView: 2, forceParse: 0});
							  </script>
						 </div>
					  </div>
					  <div class="col-sm-3" style="width: 340px;">
						  <div class="input-group input-group-sm ">
							  <span class="input-group-addon">交易结束时间</span>
							  <div class="input-group date form_datetime" data-link-field="dtp_input1">
								  <input id="q_createTime_end" name="q_createTime_end" style="height: 30px; border: 1px solid #c6c6c6;border-right:none;padding-left:10px; " size="17.5" type="text" value=""  placeholder="请选择交易结束时间" readonly>
								  <span class="input-group-addon"><span class="glyphicon glyphicon-remove"></span></span>
								  <span class="input-group-addon"><span class="glyphicon glyphicon-th"></span></span>
							  </div>
							  <script type="text/javascript">
                                  $('.form_datetime').datetimepicker({format: "yyyy-MM-dd",language:'zh-CN',weekStart:1, todayBtn:1,autoclose: 1,todayHighlight: 1,startView: 2, minView: 2, forceParse: 0});
							  </script>
						  </div>
					  </div>
					  <div class="col-sm-2">
						  <button type="button" id="btn_query" class="btn btn-primary">查询</button>&nbsp;&nbsp;
						  <button type="reset" class="btn btn-success" id="resetBtn">重置</button>
					  </div>
				  </div>
			  </form>
		  </div>
	  </div>

	  <!-- 工具栏 -->
	  <div id="toolbar" class="btn-group">
		  <shiro:hasPermission name="back_gotoCustomerStatistics_export">
			  <button id="btn_export" type="button" class="btn btn-default" onclick="exportCustomerStatisticsExcel()">
				  <span class="glyphicon glyphicon-export" aria-hidden="true"></span>&nbsp;导出报表
			  </button>
		  </shiro:hasPermission>
		  <shiro:hasPermission name="back_gotoCustomerStatistics_chartDisplay">
			  <button id="btn_signal" type="button" class="btn btn-default" onclick="">
				  <span class="glyphicon glyphicon-signal" aria-hidden="true"></span>&nbsp;图表展示
			  </button>
		  </shiro:hasPermission>
	  </div>

	  <!-- 渲染的table -->
	  <table id="tt"></table>
  </div>
  </body>
</html>